Edit dimension tables using a spreadsheet
Why use this feature
Managing Axiom Cost Accounting is often done by only a few specified users, so providing ease-of-use utilities that streamline the process of maintaining the system gives more time back to these users to perform other tasks. In an effort to efficiently update dimension tables, you can now bulk edit and import changes into the system by using the download and upload functionality.
How this feature works
Each dimension page in the system allows the appropriate user to download the dimension spreadsheet and upload the updated spreadsheet file to propagate the changes in the system
Where: In the Guide View, click Data Management to manage the different entities.
Who: Cost Accounting Admins or other users responsible for maintaining the costing process.
How: Open a dimension, and at the top of the Dimensions Maintenance page, click Download Table. Add a new dimension by adding a row, or edit the column information for an existing dimension. After you make changes to the spreadsheet, click Upload Table in the Dimension Maintenance page. The system displays information regarding the number of changes made, and the number of rows updated and/or added. You can then confirm the changes and upload the data.
Upload and download buttons on the dimension page
Example of the downloaded ENTITY dimension table in spreadsheet form
Where to find more information
The following topics include new information and instructions for using this feature:
